<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>i2c: C:/Users/Jon/Downloads/OOP/old/inc/gointerns_backup.php Source File</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />

<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>

</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">i2c
   
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.7.5.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="pages.html"><span>Related&#160;Pages</span></a></li>
      <li><a href="annotated.html"><span>Data&#160;Structures</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>Globals</span></a></li>
    </ul>
  </div>
<div class="header">
  <div class="headertitle">
<div class="title">C:/Users/Jon/Downloads/OOP/old/inc/gointerns_backup.php</div>  </div>
</div>
<div class="contents">
<a href="gointerns__backup_8php.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 &lt;?php
<a name="l00002"></a>00002 
<a name="l00003"></a>00003 include <span class="stringliteral">&#39;dbinfo.php&#39;</span>;
<a name="l00004"></a>00004 include <span class="stringliteral">&#39;opendb.php&#39;</span>;
<a name="l00005"></a>00005 echo<span class="stringliteral">&#39; &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;css/style.css&quot; /&gt;&#39;</span>;
<a name="l00006"></a>00006 
<a name="l00007"></a>00007 echo <span class="stringliteral">&quot;&lt;div align=&#39;left&#39;&gt;&lt;form action=&#39;gointerns_backup.php&#39; method=&#39;post&#39;&gt;&lt;input type=&#39;submit&#39; name=&#39;createBackup&#39; value=&#39;Create Backup&#39; class=&#39;submit&#39; /&gt;&lt;/form&gt;&lt;/div&gt;&lt;br /&gt;&quot;</span>;
<a name="l00008"></a>00008 
<a name="l00009"></a>00009 <span class="keywordflow">if</span> (isset($_POST[<span class="stringliteral">&#39;restoreButton&#39;</span>])) {
<a name="l00010"></a>00010     restoreBackup(<a class="code" href="old_2inc_2db_info_8php.html#af2db2dddb0b2b7d808588f5cda0b91cf">$db_hostname</a>, <a class="code" href="old_2inc_2db_info_8php.html#a820e0b38cf4374967d8018835e9b755d">$db_username</a>, <a class="code" href="old_2inc_2db_info_8php.html#a2962c2bda65ca19dd4dd12d7160f1bf8">$db_password</a>, <a class="code" href="old_2inc_2db_info_8php.html#a26dcb19f4431598ddd5f58147f131bee">$db_name</a>);
<a name="l00011"></a>00011 }
<a name="l00012"></a>00012 <span class="keywordflow">if</span> (isset($_POST[<span class="stringliteral">&#39;createBackup&#39;</span>])) {
<a name="l00013"></a>00013     createBackup(<a class="code" href="old_2inc_2db_info_8php.html#af2db2dddb0b2b7d808588f5cda0b91cf">$db_hostname</a>, <a class="code" href="old_2inc_2db_info_8php.html#a820e0b38cf4374967d8018835e9b755d">$db_username</a>, <a class="code" href="old_2inc_2db_info_8php.html#a2962c2bda65ca19dd4dd12d7160f1bf8">$db_password</a>, <a class="code" href="old_2inc_2db_info_8php.html#a26dcb19f4431598ddd5f58147f131bee">$db_name</a>);
<a name="l00014"></a>00014 }
<a name="l00015"></a>00015 
<a name="l00016"></a>00016 echo <span class="stringliteral">&quot;&lt;table width=&#39;400px&#39; cellspacing=0&gt;&quot;</span>;
<a name="l00017"></a>00017 echo <span class="stringliteral">&quot;&lt;tr&gt;&lt;td&gt;&lt;h2&gt;Backups&lt;/h2&gt;&lt;/td&gt;&lt;/tr&gt;&quot;</span>;
<a name="l00018"></a>00018 echo <span class="stringliteral">&quot;&lt;tr&gt;&lt;td colspan=2&gt;&lt;hr /&gt;&lt;/td&gt;&lt;/tr&gt;&quot;</span>;
<a name="l00019"></a>00019 getDirectoryList(<span class="stringliteral">&#39;backups/&#39;</span>);
<a name="l00020"></a>00020 echo <span class="stringliteral">&quot;&lt;/table&gt;&quot;</span>;
<a name="l00021"></a>00021 
<a name="l00022"></a>00022 include <span class="stringliteral">&#39;closedb.php&#39;</span>;
<a name="l00023"></a>00023 
<a name="l00024"></a>00024 <span class="keyword">function</span> restoreBackup(<a class="code" href="old_2inc_2db_info_8php.html#af2db2dddb0b2b7d808588f5cda0b91cf">$db_hostname</a>, <a class="code" href="old_2inc_2db_info_8php.html#a820e0b38cf4374967d8018835e9b755d">$db_username</a>, <a class="code" href="old_2inc_2db_info_8php.html#a2962c2bda65ca19dd4dd12d7160f1bf8">$db_password</a>, <a class="code" href="old_2inc_2db_info_8php.html#a26dcb19f4431598ddd5f58147f131bee">$db_name</a>) {
<a name="l00025"></a>00025     $filename = $_POST[<span class="stringliteral">&#39;restoreBackup&#39;</span>];
<a name="l00026"></a>00026     <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = mysql_query(<span class="stringliteral">&quot;drop database $db_name&quot;</span>);
<a name="l00027"></a>00027     <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = mysql_query(<span class="stringliteral">&quot;create database $db_name&quot;</span>);
<a name="l00028"></a>00028     <span class="keywordflow">if</span> (<a class="code" href="old_2inc_2db_info_8php.html#a2962c2bda65ca19dd4dd12d7160f1bf8">$db_password</a> == <span class="stringliteral">&#39;&#39;</span>) {
<a name="l00029"></a>00029         $command = <span class="stringliteral">&quot;mysql -h $db_hostname -u $db_username $db_name &lt; backups\\$filename&quot;</span>;
<a name="l00030"></a>00030     } <span class="keywordflow">else</span> {
<a name="l00031"></a>00031         $command = <span class="stringliteral">&quot;mysql -h $db_hostname -u $db_username -p $db_password $db_name &lt; backups\\$filename&quot;</span>;
<a name="l00032"></a>00032     }
<a name="l00033"></a>00033     system($command, <a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a>);
<a name="l00034"></a>00034     <span class="keywordflow">if</span> (<a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a>) {
<a name="l00035"></a>00035         echo <span class="stringliteral">&quot;Could not restore from backup...&quot;</span>;
<a name="l00036"></a>00036     } <span class="keywordflow">else</span> {
<a name="l00037"></a>00037         echo <span class="stringliteral">&quot;&lt;div align=&#39;left&#39;&gt;&quot;</span>;
<a name="l00038"></a>00038         echo <span class="stringliteral">&quot;&lt;h2&gt;Backup successfully restored!&lt;/h2&gt;&quot;</span>;
<a name="l00039"></a>00039         echo <span class="stringliteral">&quot;&lt;hr /&gt;&quot;</span>;
<a name="l00040"></a>00040         echo <span class="stringliteral">&quot;&lt;a href=&#39;index.php&#39;&gt;Back to the database&lt;/a&gt;&quot;</span>;
<a name="l00041"></a>00041         echo <span class="stringliteral">&quot;&lt;/div&gt;&quot;</span>;
<a name="l00042"></a>00042         die;
<a name="l00043"></a>00043     }
<a name="l00044"></a>00044 }
<a name="l00045"></a>00045 
<a name="l00046"></a>00046 <span class="keyword">function</span> createBackup(<a class="code" href="old_2inc_2db_info_8php.html#af2db2dddb0b2b7d808588f5cda0b91cf">$db_hostname</a>, <a class="code" href="old_2inc_2db_info_8php.html#a820e0b38cf4374967d8018835e9b755d">$db_username</a>, <a class="code" href="old_2inc_2db_info_8php.html#a2962c2bda65ca19dd4dd12d7160f1bf8">$db_password</a>, <a class="code" href="old_2inc_2db_info_8php.html#a26dcb19f4431598ddd5f58147f131bee">$db_name</a>) {
<a name="l00047"></a>00047 
<a name="l00048"></a>00048     $backupFile = date(<span class="stringliteral">&#39;Y-m-d-H-i-s&#39;</span>) . <span class="stringliteral">&#39;.sql&#39;</span>;
<a name="l00049"></a>00049     <span class="keywordflow">if</span> (<a class="code" href="old_2inc_2db_info_8php.html#a2962c2bda65ca19dd4dd12d7160f1bf8">$db_password</a> == <span class="stringliteral">&#39;&#39;</span>) {
<a name="l00050"></a>00050         $command = <span class="stringliteral">&quot;mysqldump -h $db_hostname -u $db_username $db_name &gt; backups\\$backupFile&quot;</span>;
<a name="l00051"></a>00051     } <span class="keywordflow">else</span> {
<a name="l00052"></a>00052         $command = <span class="stringliteral">&quot;mysqldump -h $db_hostname -u $db_username -p $db_password $db_name &gt; backups\\$backupFile&quot;</span>;
<a name="l00053"></a>00053     }
<a name="l00054"></a>00054     system($command, <a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a>);
<a name="l00055"></a>00055     <span class="keywordflow">if</span> (<a class="code" href="index_8php.html#aeba2ab722cedda53dbb7ec1a59f45550">$error</a>
<a name="l00056"></a>00056         )die(<span class="stringliteral">&quot;&lt;h1&gt;Backup failed!&lt;/h1&gt;&quot;</span>);
<a name="l00057"></a>00057     echo <span class="stringliteral">&quot;&lt;div align=&#39;left&#39;&gt;&lt;h1&gt;Backup successfully created!&lt;/h1&gt;&lt;/div&gt;&quot;</span>;
<a name="l00058"></a>00058 }
<a name="l00059"></a>00059 
<a name="l00060"></a>00060 <span class="keyword">function</span> getDirectoryList($directory) {
<a name="l00061"></a>00061 
<a name="l00062"></a>00062     $results = array();
<a name="l00063"></a>00063     $handler = opendir($directory);
<a name="l00064"></a>00064     $i = 0;
<a name="l00065"></a>00065     <span class="keywordflow">while</span> ($file = readdir($handler)) {
<a name="l00066"></a>00066         <span class="keywordflow">if</span> ($file != <span class="stringliteral">&quot;.&quot;</span> &amp;&amp; $file != <span class="stringliteral">&quot;..&quot;</span>) {
<a name="l00067"></a>00067             $i++;
<a name="l00068"></a>00068             <span class="keywordflow">if</span> ($i % 2 == 0) {
<a name="l00069"></a>00069                 echo <span class="stringliteral">&quot;&lt;tr bgcolor=&#39;#FBFBFB&#39;&gt;&quot;</span>;
<a name="l00070"></a>00070             } <span class="keywordflow">else</span> {
<a name="l00071"></a>00071                 echo <span class="stringliteral">&quot;&lt;tr&gt;&quot;</span>;
<a name="l00072"></a>00072             }
<a name="l00073"></a>00073             echo <span class="stringliteral">&quot;&lt;td valign=&#39;middle&#39; align=&#39;center&#39;&gt;&quot;</span>;
<a name="l00074"></a>00074             echo <span class="stringliteral">&quot;&lt;form action=&#39;gointerns_backup.php&#39; method=&#39;post&#39;&gt;&quot;</span>;
<a name="l00075"></a>00075             echo <span class="stringliteral">&quot;&lt;input type=&#39;hidden&#39; name=&#39;restoreBackup&#39; value=&#39;$file&#39; /&gt;&quot;</span>;
<a name="l00076"></a>00076             echo <span class="stringliteral">&quot;$file&lt;/td&gt;&lt;td&gt;&lt;input type=&#39;submit&#39; class=&#39;submit&#39; name=&#39;restoreButton&#39; value=&#39;RESTORE&#39; /&gt;&quot;</span>;
<a name="l00077"></a>00077             echo <span class="stringliteral">&quot;&lt;/form&gt;&lt;/td&gt;&lt;/tr&gt;&quot;</span>;
<a name="l00078"></a>00078         }
<a name="l00079"></a>00079     }
<a name="l00080"></a>00080     closedir($handler);
<a name="l00081"></a>00081 }
<a name="l00082"></a>00082 
<a name="l00083"></a>00083 ?&gt;
</pre></div></div>
</div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Data Structures</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>



<hr class="footer"/><address class="footer"><small>
Generated on Tue Nov 29 2011 18:18:55 for i2c by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.7.5.1
</small></address>

</body>
</html>
